#!/bin/bash
hive -f ./ods_base_acd_file_d_f.sql
hive -e "alter table ods.ods_base_acd_file_d_f add if not exists partition (pt = 20250610)"
hive -f ./ods_base_acd_filehuman_d_f.sql
hive -e "alter table ods.ods_base_acd_filehuman_d_f add if not exists partition (pt = 20250610)"
hive -f ./ods_base_bd_drivinglicense_d_f.sql
hive -e "alter table ods.ods_base_bd_drivinglicense_d_f add if not exists partition (pt = 20250610)"
hive -f ./ods_base_bd_vehicle_d_f.sql
hive -e "alter table ods.ods_base_bd_vehicle_d_f add if not exists partition (pt = 20250610)"
hive -f ./ods_base_cards_pos_d_f.sql
hive -e "alter table ods.ods_base_cards_pos_d_f add if not exists partition (pt = 20250610)"
hive -f ./ods_base_vio_force_d_f.sql
hive -e "alter table ods.ods_base_vio_force_d_f add if not exists partition (pt = 20250610)"
hive -f ./ods_base_vio_surveil_d_f.sql
hive -e "alter table ods.ods_base_vio_surveil_d_f add if not exists partition (pt = 20250610)"